package com.cis467.mrball.backend;

public class DatabaseConstants {

	// SQLite Types
	public static final String NULL 	= "NULL";
	public static final String INTEGER 	= "INTEGER";
	public static final String REAL		= "REAL";
	public static final String TEXT		= "TEXT";
	public static final String BLOB		= "BLOB";
	
	// General Database Constants
	public static final String DATABASE_NAME = "MrBallDatabase";
	public static final int DATABASE_VERSION = 1;
	
	// Level Table Constants
	public static final String TABLE_LEVELS = "Levels";
	public static final String FIELD_CREATOR = "Creator";
	public static final String FIELD_LEVEL_NAME = "LevelName";
	public static final String FIELD_LEVEL_BATCH = "LevelBatch";
	public static final String FIELD_LEVEL_NUMBER = "LevelNumber";
	public static final String FIELD_LEVEL_XML = "LevelXML";
	public static final String FIELD_PERSONAL_BEST = "PersonalBest";
	public static final String FIELD_WORLD_RECORD = "WorldRecord";
	public static final String FIELD_LOCAL_VOTE = "LocalVote";
	public static final String FIELD_SERVER_VOTE = "ServerVote";
	public static final String FIELD_UPVOTES = "Upvotes";
	public static final String FIELD_DOWNVOTES = "Downvotes";
	public static final String CONSTRAINT_1 = "Unique1"; // Unique(Creator, LevelName, LevelBatch)
	public static final String CONSTRAINT_2 = "Unique2"; // Unique(Creator, LevelBatch, LevelNumber)

	
	
	// Standard Batch Names
	// TODO may want to locate these in DB for security reasons
	public static final String BATCH_CORE = "Core";
	public static final String BATCH_BUILT = "Built";
	public static final String BATCH_DOWNLOADED = "Downloaded";
}
